CS185c Spring 2010Practice Midterm

To study for the midterm I would suggest you: (1) Know how to do (by heart) all the practice problems. (2) Go over your notes at least three times. Second and third time try to see how much you can remember from the first time. (3) Go over the homework problems. (4) Try to create your own problems similar to the ones I have given and solve them. (5) Skim the relevant sections from the book. (6) If you want to study in groups, at this point you are ready to quiz each other. The practice midterm is below. Here are some facts about the actual midterm: (a) It is closed book, closed notes. Nothing will be permitted on your desk except your pen (pencil) and test. (b) You should bring photo ID. (c) There will be more than one version of the test. Each version will be of comparable difficulty. (d) One problem (less typos) on the actual test will be from the practice test. (e) One problem on the actual test will be about one of my HW solutions.

1. When was DB2 first released? What system was it a descendant of? Do DB2 products written for different OSs share the same codebase?

2. Briefly described each of the following table types: temporary table, materialized query table, auxiliary table, and clone table.

3. What does EDM stand for? What is it used for within DB2? What is the EDM RDS Section pool ?

4. Briefly describe how LOB and XML tablespaces are associated with a LOB or XML column in DB2. If a base table is partitioned what happens to corresponding LOB and XML tablespaces?

5. What are the roles of the following two DB2 address spaces MSTR and DBM1?

6. Which subcomponents of the RDS are invoked when a DML statement is executed? What about for a DDL or DCL statement?

7. What is the difference between doing a relation scan and an index scan? Which components of the DM would be involved in each case?

8. Briefly describe each of the following kinds of locks: share lock, exclusive lock, update lock.

9. What is a service class? Give three pre-defined service classes of z/OS.

10. Give a complete SQL statement (not just the name like SELECT) of each of the following types: DML, DDL.